About the EncounteredMetadataFieldList Table

This table exists in the Client (level) database. The selection of metadata fields for QC, Export, Endorsement, and/or Placeholders are based on the active Client.

The EncounteredMetadataFieldList table consists of two columns: Fieldname and Display.

• Fieldname: The Fieldname column contains the meta field name.
• Display: The Display column is populated with a value of 1 to indicate the meta field will display in the Available Fields list box located in the Custom Placeholder Configuration dialog box.

If you want to exclude certain meta fields from displaying in the Available Meta Fields List, the SQL Database Administrator must update the Display column in the EncounteredMetadataFieldList table by changing the Display value of 1 to a Display value of 0. A value of 0 indicates the meta field will not display in the Available Fields list box located in the Custom Placeholder Configuration dialog box.

The EncounteredMetadataFieldList table lists all unique mapped field names pulled from the Client’s MetadataExtended and DataExtractMetadataExtended tables. This is the list of fields that are displayed at export time.

 

Related Topics

Create a Processed Data Export Job